{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["TITLE PAGE","ENTER DATA","CODE TABLES","Validation Errors","Version History"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":51,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TITLE PAGE","index":0,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[37,1,37,5],[15,3,15,4],[4,3,4,4],[7,3,7,4],[9,3,9,4],[11,3,11,4],[13,3,13,4],[39,1,39,5],[38,1,38,5],[40,1,40,5],[43,1,43,5],[44,1,44,5]]}
[null,{"$error":"#VALUE!"},"Health Sector Compensation Information System"]
[null,"HSCIS File Developer Tool",null,null,null,"Version 1.1"]
[]
[]
[null,"Extract Information",null,"HNFile Preparer Contact Information"]
[]
[null,"Corporate Employer Number:",null,"Name:"]
[]
[null,"Legal Name:",null,"Position:"]
[]
[null,"Reporting from Date:",null,"E-mail:"]
[]
[null,"Reporting to Date:",null,"Phone Number:"]
[]
[null,null,null,"Date Data Prepared:"]
[]
[]
[]
[null,"Data Checks"]
[]
[null,"Data Field",null,"Min ","Max","Total Balance"]
[null,"D14 Wage rate ",null,{"$f":"MIN('ENTER DATA'!Q2:Q953)","v":0},{"$f":"MAX('ENTER DATA'!Q2:Q953)","v":0},"N/A"]
[null,"D15 Regular Paid hours ",null,{"$f":"MIN('ENTER DATA'!R$2:R$953)","v":0},{"$f":"MAX('ENTER DATA'!R$2:R$953)","v":0},{"$f":"SUM('ENTER DATA'!R2:R953)","v":0}]
[null,"D17 Vacation Hours Used in the Year ",null,{"$f":"MIN('ENTER DATA'!T$2:T$953)","v":0},{"$f":"MAX('ENTER DATA'!T$2:T$953)","v":0},{"$f":"SUM('ENTER DATA'!T2:T953)","v":0}]
[null,"D37 Sick Leave Bank ",null,{"$f":"MIN('ENTER DATA'!AN$2:AN$953)","v":0},{"$f":"MAX('ENTER DATA'!AN$2:AN$953)","v":0},{"$f":"SUM('ENTER DATA'!AN2:AN953)","v":0}]
[null,"D64 CPP ",null,{"$f":"MIN('ENTER DATA'!BO$2:BO$953)","v":0},{"$f":"MAX('ENTER DATA'!BO$2:BO$953)","v":0},{"$f":"SUM('ENTER DATA'!BO2:BO953)","v":0}]
[null,"D65 EI ",null,{"$f":"MIN('ENTER DATA'!BP$2:BP$953)","v":0},{"$f":"MAX('ENTER DATA'!BP$2:BP$953)","v":0},{"$f":"SUM('ENTER DATA'!BP2:BP953)","v":0}]
[null,null,null,null,null,"These fields auto-populate based on the data submittted in the 'ENTER DATA' worksheet. Check that the values and balances align with the reporting in your payroll system before extracting the data."]
[]
[null,"Data Field",null,"Casual","Part Time","Full Time"]
[null,"D16 Job Status (Number of Employees)",null,{"$f":"COUNTIF('ENTER DATA'!S2:S953,\"C\")","v":0},{"$f":"COUNTIF('ENTER DATA'!S2:S953,\"P\")","v":0},{"$f":"COUNTIF('ENTER DATA'!S2:S953,\"F\")","v":0}]
[null,null,null,null,"Total Unique SIN",{"$f":"COUNTA(_xlfn.UNIQUE((_xlfn._xlws.FILTER('ENTER DATA'!F2:F953,'ENTER DATA'!F2:F953<>\"\"))))","v":1}]
[null,null,null,null,null,"These fields auto-populate based on the data submitted in the 'ENTER DATA' worksheet. Check that the number of employees allign with your payroll system before exporting the data."]
[]
[]
[null,"Functions/Buttons"]
[]
[null,"FORMAT DATES To YYYY-MM-DD - This button re-orders the numbers in all date cells. All dates must be in the same original format to prevent errors."]
[null,"ARCHIVE DATA - This button saves a copy of the 'TITLE PAGE' and 'ENTER DATA' page in a new workbook. The new file is dated and saved for future referencing."]
[null,"EXPORT DATA - This button exports the data in the workbook into the HNFile .txt file needed to report to HSCIS. This file  can then be submitted in the HSCIS application."]
[null,"CLEAR DATA - Clear Report - This button is used to clear the workbook for a new reporting period. The current data is archived and saved in a new workbook then most of the fields are deleted for the next reporting period. Several fields will remain to make manual entry easier. "]
[]
[null,"Notes"]
[null,"- For a comprehensive user guide and support, please contact HLTH.HscisSupport@gov.bc.ca"]
[null,"- Please check that there are no 'Red' filled cells in the \"ENTER DATA\" worksheet before extracting the data. "]

{"sheet":"ENTER DATA","index":1,"n_rows":1,"n_cols":85,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["D2 \nDesignated Group ","D3  \nUnion ","D4 \nSite Employer Number ","D5 \nDate of Birth ","D6 \nEmployee Number ","D7  \nEmployee SIN ","D8a \nPosition FTE (No longer required) ","D8b \nLayered-over Positions – Class Code ","D8C \nIntegrated Position ","D8D   \nOriginal Date of Hire with Current Employer ","D8E \nDate of Hire in Current position ","D9 \nBlank ","D10 \nGender ","D11 \nJob Title ","D12 \nClassification Code ","﻿D13 \nIncrement ","D14 \nWage rate ","D15 \nRegular Paid hours ","D16 \nJob Status ","D17 \nVacation Hours Used in the Year ","D18 \nVacation Entitlement / Service Date ","D19 \nSeniority Start Date ","D20 \nPaid Statutory Holidays ","D21 \nPay for Relieving in Higher Rated Position ","D22 \nPremium Pay for Hours worked on Statutory Holidays @1.5 ","D23 \nPremium Pay for Hours worked on Statutory Holidays @2.0 ","D24 \nPremium Pay for Hours worked on Statutory Holidays @2.5 ","﻿D25 \nRegular Work Day Overtime @1.5 ","D26 \nRegular Work Day Overtime @2.0 ","D27 \nRegular Day off Overtime @1.5 ","D28 \nRegular Day off Overtime @2.0 ","D29 \nOvertime for Insufficient Notice @1.5 ","D30 \nOvertime for Insufficient Notice @2.0 ","D31 \nCall-back @1.5 ","D32 \nCall-back @2.0 ","D33 \nOther overtime @1.5 ","D34 \nOther overtime @2.0 ","﻿D35 \nTotal Overtime @1.5 ","D36 \nTotal Overtime @2.0 ","D37 \nSick Leave Bank ","D38 \nSick Leave Paid ","D39 \nSick Leave Cash Payout ","D40 \nSpecial Leave ","D41 \nCompassionate Leave ","D42 \nJury Duty ","D43 \nEmployer Paid Union Business ","D44 \nEducation Leave ","D45 \nTime Off in Lieu  (Banked OT & CTO) ","D46 \nAll Other Paid Leaves ","D47 \nPaid Leave while on WCB ","D48 \nOn-call Meal Periods ","D49 \nShift Premiums – Evenings ","D50 \nShift Premiums – Nights ","D51 \nShift Premiums – Weekends ","D52 \nOn-call Differentials (Primary Rate) ","D53 \nQualification Differentials ","D54 \nResponsibility Pay/Special Allowance ","﻿D55 \nTravel Allowance ","D56 \nUniform Allowance ","D57 \nIsolation Allowance ","D58 \nMeal Allowance ","D59 \nSeverance Allowance Paid ","D60 \nMaternity/Paternal Leave SEB Plan ","D61 \nOther Premiums/Allowances ","D62 \nSuperannuation ","D63 \nPension Plan/RRSP ","D64 \nCPP ","D65 \nEI ","D66 \nWCB ","D67 \nCasual Statutory Holiday/Vacation Pay ","D68 \nHome Support Holiday Lieu Pay ","﻿D69 \nMSP (Total Contributions) ","D70 \nDental (Total Contributions) ","D71 \nExtended Health (Total Contributions) ","D72 \nGroup Life/AD&D (Total Contributions) ","D73 \nLong Term Disability (Total Contributions) ","D74 \nEmployee Termination Date ","D75 \nRetroactive and lump sum payout ","D76 \nSuper Shift Premium ","D77 \nTermination Code ","D78 \nDifficult-to-Fill Unit Premium ","D79 \nOn-Call Differentials (Second earnings rate) ","D80 \nTelephone Consultation Pay ","﻿D81 \nLive-In Pay ","D82 \nOvernight Pay "]

{"sheet":"CODE TABLES","index":2,"n_rows":161,"n_cols":4,"rows_kept":161,"cut":false,"hidden":false,"merged":[]}
[null,"HSCIS CODE TABLES"]
[null,null,"CODE","DESCRIPTION"]
[null,"DESIGNATED GROUP","A","Ambulance Paramedics and Dispatchers = (HEABC Ambulance Paramedics and Dispatchers agreement)"]
[null,null,"B","Bargaining Unit Equivalent = (Non-union positions that would be included if a union existed)"]
[null,null,"C","Community = (HEABC Community Subsector agreement)"]
[null,null,"D","Physicians on staff = (Physicians on staff)"]
[null,null,"E","Executive/Excluded = (Executive, Management, and confidential staff)"]
[null,null,"F","Facilities = (HEABC Facilities Subsector agreement)"]
[null,null,"N","Nurses = (HEABC Nurses Subsector agreement)"]
[null,null,"P","Health Science Professionals/Paramedicals = (HEABC Health Sciences / Paramedical agreement)"]
[null,null,"R","Resident Doctors of British Columbia = (HEABC Resident Doctors of British Columbia agreement)"]
[null,null,"S","Collective Agreements other than HEABC-negotiated agreements = (Collective agreements other than HEABC-negotiated agreements)"]
[]
[null,null,"CODE","DESCRIPTION"]
[null,"Class Code Range","E Min",1000]
[null,null,"E Max",9999]
[null,null,"F/A Min",10001]
[null,null,"F/A Max",20999]
[null,null,"N Min",12001]
[null,null,"N Max",29999]
[null,null,"P Min",30300]
[null,null,"P Max",69999]
[null,null,"D Min",70000]
[null,null,"D Max",70312]
[null,null,"S Min",76000]
[null,null,"S Max",78999]
[null,null,"C Min",80101]
[null,null,"C Max",89899]
[null,null,"B Min",96000]
[null,null,"B Max",98999]
[null,null,"R Min",999100]
[null,null,"R Max",99799]
[]
[null,null,"CODE","DESCRIPTION"]
[null,"GENDER","F","Female"]
[null,null,"M","Male"]
[null,null,"X","Undeclared"]
[null,null,"U","Undisclosed or Unknown"]
[]
[null,null,"CODE","DESCRIPTION"]
[null,"JOB STATUS","C","Casual"]
[null,null,"F","Regular Full Time"]
[null,null,"P","Regular Part Time"]
[]
[null,null,"CODE","DESCRIPTION"]
[null,"TERMINATION",0,"Active/Working (Can be left blank in the 'ENTER DATA; workbook)"]
[null,null,1,"Accepted Employment - Other BC Employer"]
[null,null,2,"Accepted Employment - Other Province"]
[null,null,3,"Accepted Employment - Other Country"]
[null,null,4,"Dismissal"]
[null,null,5,"Retirement"]
[null,null,6,"Layoff"]
[null,null,7,"Quit"]
[null,null,8,"Other"]
[null,null,9,"Death in Service"]
[]
[null,null,"CODE","DESCRIPTION"]
[null,"UNION","B1","BCGEU - BC General Employees Union"]
[null,null,"B2","BCNU - British Columbia Nurses Union"]
[null,null,"B3","BCH - BC Handbook (Related to the Good Samaritan Society only)"]
[null,null,"C1","CAW - National Automobile Aerospace Transportation and General Workers Union of Canada (CAW Local 4100)"]
[null,null,"C2","CLAC - Christian Labour Association of Canada"]
[null,null,"C3","CSWU - Construction and Specialised Workers Union"]
[null,null,"C4","CUPE - Canadian Union of Public Employees"]
[null,null,"H1","HEU - Hospital Employees Union"]
[null,null,"H2","HSA - Health Sciences Association of BC"]
[null,null,"I1","IBEW - International Brotherhood of Electrical Workers"]
[null,null,"I2","IUPAT - International Union of Painters & Allied Trades District Council"]
[null,null,"I3","IUOE - International Union of Operating Engineers"]
[null,null,"I4","IWA - Industrial Wood and Allied Workers of Canada"]
[null,null,"P2","PEA - Professional Employees Association"]
[null,null,"P3","PolyParty (HEU and BCGEU)"]
[null,null,"P4","PolyParty (HEU and BCGEU"]
[null,null,"P5","PPWC - Public and Private Workers of Canada"]
[null,null,"R1","RDBC - Resident Doctors of British Columbia"]
[null,null,"T1","TEAMSTERS - International Brotherhood of Teamsters General Truck Drivers and Helpers"]
[null,null,"U1","UAPP - United Association of Plumbers & Pipefitters"]
[null,null,"U2","UBCJA - United Brotherhood of Carpenters and Joiners of America"]
[null,null,"U3","UFCW - United Food and Commercial Workers Union"]
[null,null,"U4","UPN - Union of Psychiatric Nurses"]
[null,null,"U5","USWA - United Steelworkers of America"]
[null,null,"N1","Non-union"]
[]
[null,null,"CODE","DESCRIPTION"]
[null,"FUNDING SOURCE",1,"Health Authority Programs - Acute & Tertiary"]
[null,null,2,"Health Authority Programs - Continuing Care Residential"]
[null,null,3,"Health Authority Programs - Continuing Care Community"]
[null,null,4,"Health Authority Programs - Adult Mental Health"]
[null,null,5,"Health Authority Programs - Public & Preventive Health"]
[null,null,6,"Health Authority Programs - Other"]
[null,null,7,"Health Authority Programs - AIDS Programs"]
[null,null,8,"Ministry of Health - Directly Funded Programs"]
[null,null,9,"Ministry of Children & Families - Child Development Centres"]
[null,null,10,"Health Authority Programs - Alcohol & Drug Centres"]
[null,null,11,"Ministry of Children & Families - Other"]
[null,null,12,"Other Provincial Government Funding (Excluding User Fees)"]
[null,null,13,"User Fee for Provincially Funded Programs"]
[null,null,14,"Private Pay Clients"]
[null,null,15,"Federal Government (funding of client support)"]
[null,null,16,"Miscellaneous funding (gifts, fund raising, other)"]
[null,null,17,"BC Housing and other mortgage subsidies"]
[null,null,18,"Ministry of Social Development (Excluding user fees)"]
[]
[null,null,"CODE","DESCRIPTION"]
[null,"EMPLOYEE STATUS","A","Active"]
[null,null,"E","Education Leave"]
[null,null,"L","Long Term Disability"]
[null,null,"M","Maternity Leave"]
[null,null,"T","Terminated from position"]
[null,null,"U","Other Unpaid Leave "]
[null,null,"W","Workers' Compensation Leave"]
[]
[null,null,"CODE","DESCRIPTION"]
[null,"HEALTH SECTOR","ACUTE","Acute Care"]
[null,null,"HCCR","Home & Community Care - Residential"]
[null,null,"HCCO","Home & Community Care - Other"]
[null,null,"MHA","Mental Health & Addictions"]
[null,null,"PHW","Population Health & Wellness"]
[null,null,"CORP","Corporate"]
[]
[null,null,"CODE","DESCRIPTION"]
[null,"INCREMENT",0]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,"X","= Increment '10'"]
[]
[]
[null,"VALIDATION RANGES"]
[null,null,"Range","Value"]
[null,"DOB","MIN",14]
[null,null,"MAX",80]
[]
[null,null,"Range","Value"]
[null,"WAGE RATE","MIN",13.5]
[null,null,"MAX",200]
[]
[null,null,"Range","Value"]
[null,"REGULAR PAID HOURS","MIN",0]
[null,null,"MAX",2200]
[]
[null,null,"Range","Value"]
[null,"CPP","MIN",0]
[null,null,"MAX",4430.1000000000004]
[]
[null,null,"Range","Value"]
[null,"EI","MIN",0]
[null,null,"MAX",1600]
[]
[]
[null,"Record Types"]
[null,"Record","Header","H"]
[null,null,"Detailed","D"]
[null,null,"Trailer","T"]

{"sheet":"Validation Errors","index":3,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Timestamp","Section","Row","Column","Field","Message"]

{"sheet":"Version History","index":4,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[null,{"$error":"#VALUE!"},null,"Health Secor Compensation Information System"]
[null,"HSCIS File Developer Tool - Verion History"]
[]
[]
[null,"Version History"]
[]
[null,"Description","Version","Date Changed","Editor","Comments"]
[null,"Initial Copy","Version 1.0",null,"Merin Pearce","Initial copy released to the pilot group."]
[null,"Date Format Macro Simplified","Version 1.1","2025-12-30","Merin Pearce","Simplified Date Formatting macro & Updated user guide."]